drop database if exists ripple_contract;
create database ripple_contract default character set utf8mb4 collate utf8mb4_general_ci;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ripple_contract_currency
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_currency`;
CREATE TABLE `ripple_contract_currency` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '名称',
  `logo` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图标',
  `scale` int NOT NULL COMMENT '精度',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态(0停用 1正常)',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='货币表';

-- ----------------------------
-- Records of ripple_contract_currency
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_funding_rate_history
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_funding_rate_history`;
CREATE TABLE `ripple_contract_funding_rate_history` (
  `id` bigint NOT NULL COMMENT '主键',
  `funding_rate` decimal(16,8) NOT NULL COMMENT '资金费率',
  `date_time` datetime NOT NULL COMMENT '费率变更时间',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `funding_rate_interval` int NOT NULL COMMENT '资金费率间隔',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='资金费率历史';

-- ----------------------------
-- Records of ripple_contract_funding_rate_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_12h
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_12h`;
CREATE TABLE `ripple_contract_k_line_12h` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_12h';

-- ----------------------------
-- Records of ripple_contract_k_line_12h
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_15min
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_15min`;
CREATE TABLE `ripple_contract_k_line_15min` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_15min';

-- ----------------------------
-- Records of ripple_contract_k_line_15min
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_1day
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_1day`;
CREATE TABLE `ripple_contract_k_line_1day` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_1day';

-- ----------------------------
-- Records of ripple_contract_k_line_1day
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_1h
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_1h`;
CREATE TABLE `ripple_contract_k_line_1h` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_1h';

-- ----------------------------
-- Records of ripple_contract_k_line_1h
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_1min
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_1min`;
CREATE TABLE `ripple_contract_k_line_1min` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_1min';

-- ----------------------------
-- Records of ripple_contract_k_line_1min
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_1month
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_1month`;
CREATE TABLE `ripple_contract_k_line_1month` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_1month';

-- ----------------------------
-- Records of ripple_contract_k_line_1month
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_1week
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_1week`;
CREATE TABLE `ripple_contract_k_line_1week` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_1week';

-- ----------------------------
-- Records of ripple_contract_k_line_1week
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_30min
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_30min`;
CREATE TABLE `ripple_contract_k_line_30min` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_30min';

-- ----------------------------
-- Records of ripple_contract_k_line_30min
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_4h
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_4h`;
CREATE TABLE `ripple_contract_k_line_4h` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_4h';

-- ----------------------------
-- Records of ripple_contract_k_line_4h
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_k_line_5min
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_k_line_5min`;
CREATE TABLE `ripple_contract_k_line_5min` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `open_price` decimal(32,8) NOT NULL COMMENT '开盘价',
  `close_price` decimal(32,8) NOT NULL COMMENT '收盘价',
  `high_price` decimal(32,8) NOT NULL COMMENT '最高价',
  `low_price` decimal(32,8) NOT NULL COMMENT '最低价',
  `deal_num` decimal(32,8) NOT NULL COMMENT '成交量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  `deal_price` decimal(32,8) DEFAULT NULL COMMENT '成交额',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ripple_contract_kline_create_time_index` (`symbol_id`,`start_time`) USING BTREE,
  UNIQUE KEY `ripple_contract_k_line_index` (`symbol_id`,`start_time`,`end_time`) USING BTREE COMMENT '唯一索引，查询必定用',
  KEY `ripple_contract_k_line_symbol_name_index` (`symbol_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='k线数据表_5min';

-- ----------------------------
-- Records of ripple_contract_k_line_5min
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_optional_symbol
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_optional_symbol`;
CREATE TABLE `ripple_contract_optional_symbol` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='自选行情表';

-- ----------------------------
-- Records of ripple_contract_optional_symbol
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_order
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_order`;
CREATE TABLE `ripple_contract_order` (
  `id` bigint NOT NULL COMMENT '主键',
  `client_order_id` varchar(50) DEFAULT NULL COMMENT '客户自定义订单id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类型（0市价单、1限价单、2强平单）',
  `position_id` bigint DEFAULT NULL COMMENT '仓位id，平仓时不为空',
  `position_mode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位模式（0逐仓、1全仓）',
  `side` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '方向（0做多、1做空）',
  `operation_type` varchar(10) NOT NULL COMMENT '操作类型（0开仓、1平仓）',
  `is_buy` varchar(10) NOT NULL COMMENT '是否是买单（0否，是卖单、1是买单）',
  `is_robot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否机器人（0否、1是）',
  `price` decimal(32,8) NOT NULL COMMENT '价格',
  `num` decimal(32,8) NOT NULL COMMENT '数量',
  `multiple` int NOT NULL COMMENT '倍数',
  `deal_amount` decimal(32,8) NOT NULL COMMENT '成交金额',
  `deal_num` decimal(32,8) NOT NULL COMMENT '已成交数量',
  `no_deal_amount` decimal(32,8) NOT NULL COMMENT '未成交金额',
  `no_deal_num` decimal(32,8) NOT NULL COMMENT '未成交数量',
  `order_value` decimal(32,8) NOT NULL COMMENT '订单面值',
  `deal_avg` decimal(32,8) DEFAULT NULL COMMENT '成交均价',
  `handling_fee` decimal(32,8) NOT NULL COMMENT '手续费',
  `liquidate_fee` decimal(32,8) DEFAULT NULL COMMENT '强平清算费',
  `margin` decimal(32,8) NOT NULL COMMENT '保证金',
  `frozen_amount` decimal(32,8) DEFAULT NULL COMMENT '冻结保证金，开仓时冻结',
  `profit` decimal(32,8) DEFAULT NULL COMMENT '收益，平仓时有值',
  `profit_rate` decimal(32,8) DEFAULT NULL COMMENT '收益率，平仓时有值',
  `has_stop_profit` varchar(10) DEFAULT NULL COMMENT '是否止盈（0否、1是）',
  `stop_profit_trigger` decimal(32,8) DEFAULT NULL COMMENT '止盈触发价格，是否止盈为是时不能为空',
  `stop_profit_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止盈价格类型（0市价、1限价），是否止盈为是时不能为空',
  `stop_profit_price` decimal(32,8) DEFAULT NULL COMMENT '止盈价格，止盈价格类型为限价时不能为空',
  `has_stop_lost` varchar(10) DEFAULT NULL COMMENT '是否止损（0否、1是）',
  `stop_lost_trigger` decimal(32,8) DEFAULT NULL COMMENT '止损触发价格，是否止损为是时不能为空',
  `stop_lost_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止损价格类型（0市价、1限价），是否止损为是时不能为空',
  `stop_lost_price` decimal(32,8) DEFAULT NULL COMMENT '止损价格，止损价格类型为限价时不能为空',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '委托状态（0委托中、1部分成交、2部分已撤销、3完全成交、4已撤销、5已过期）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_order_status_user_id_symbol_id_side_index` (`status`,`user_id`,`symbol_id`,`side`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='订单表';

-- ----------------------------
-- Records of ripple_contract_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_order_history
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_order_history`;
CREATE TABLE `ripple_contract_order_history` (
  `id` bigint NOT NULL COMMENT '主键',
  `client_order_id` varchar(50) DEFAULT NULL COMMENT '客户自定义订单id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类型（0市价单、1限价单、2强平单）',
  `position_id` bigint DEFAULT NULL COMMENT '仓位id，平仓时不为空',
  `position_mode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位模式（0逐仓、1全仓）',
  `side` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '方向（0做多、1做空）',
  `operation_type` varchar(10) NOT NULL COMMENT '操作类型（0开仓、1平仓）',
  `is_buy` varchar(10) NOT NULL COMMENT '是否是买单（0否，是卖单、1是买单）',
  `is_robot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否机器人（0否、1是）',
  `price` decimal(32,8) NOT NULL COMMENT '价格',
  `num` decimal(32,8) NOT NULL COMMENT '数量',
  `multiple` int NOT NULL COMMENT '倍数',
  `deal_amount` decimal(32,8) NOT NULL COMMENT '成交金额',
  `deal_num` decimal(32,8) NOT NULL COMMENT '已成交数量',
  `no_deal_amount` decimal(32,8) NOT NULL COMMENT '未成交金额',
  `no_deal_num` decimal(32,8) NOT NULL COMMENT '未成交数量',
  `order_value` decimal(32,8) NOT NULL COMMENT '订单面值',
  `deal_avg` decimal(32,8) DEFAULT NULL COMMENT '成交均价',
  `handling_fee` decimal(32,8) NOT NULL COMMENT '手续费',
  `liquidate_fee` decimal(32,8) DEFAULT NULL COMMENT '强平清算费',
  `margin` decimal(32,8) NOT NULL COMMENT '保证金',
  `frozen_amount` decimal(32,8) DEFAULT NULL COMMENT '冻结保证金，开仓时冻结',
  `profit` decimal(32,8) DEFAULT NULL COMMENT '收益，平仓时有值',
  `profit_rate` decimal(32,8) DEFAULT NULL COMMENT '收益率，平仓时有值',
  `has_stop_profit` varchar(10) DEFAULT NULL COMMENT '是否止盈（0否、1是）',
  `stop_profit_trigger` decimal(32,8) DEFAULT NULL COMMENT '止盈触发价格，是否止盈为是时不能为空',
  `stop_profit_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止盈价格类型（0市价、1限价），是否止盈为是时不能为空',
  `stop_profit_price` decimal(32,8) DEFAULT NULL COMMENT '止盈价格，止盈价格类型为限价时不能为空',
  `has_stop_lost` varchar(10) DEFAULT NULL COMMENT '是否止损（0否、1是）',
  `stop_lost_trigger` decimal(32,8) DEFAULT NULL COMMENT '止损触发价格，是否止损为是时不能为空',
  `stop_lost_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止损价格类型（0市价、1限价），是否止损为是时不能为空',
  `stop_lost_price` decimal(32,8) DEFAULT NULL COMMENT '止损价格，止损价格类型为限价时不能为空',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '委托状态（0委托中、1部分成交、2部分已撤销、3完全成交、4已撤销、5已过期）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='历史订单表';

-- ----------------------------
-- Records of ripple_contract_order_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_position
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_position`;
CREATE TABLE `ripple_contract_position` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `mode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位模式（0逐仓、1全仓）',
  `side` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '方向（0做多、1做空）',
  `multiple` int NOT NULL COMMENT '倍数',
  `is_robot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否机器人（0否、1是）',
  `open_num` decimal(32,8) NOT NULL COMMENT '已开仓量',
  `close_num` decimal(32,8) NOT NULL COMMENT '已平仓量',
  `now_num` decimal(32,8) NOT NULL COMMENT '当前持仓量',
  `max_num` decimal(32,8) NOT NULL COMMENT '最大持仓量',
  `available_num` decimal(32,8) DEFAULT NULL COMMENT '可用数量',
  `closing_num` decimal(32,8) DEFAULT NULL COMMENT '平仓中冻结量',
  `open_avg_price` decimal(32,8) NOT NULL COMMENT '开仓均价',
  `close_avg_price` decimal(32,8) DEFAULT NULL COMMENT '平仓均价',
  `margin` decimal(32,8) NOT NULL COMMENT '保证金',
  `profit` decimal(32,8) DEFAULT NULL COMMENT '平仓收益，平仓后有值',
  `profit_rate` decimal(32,8) DEFAULT NULL COMMENT '平仓收益率，平仓后有值',
  `liquidate_price` decimal(32,8) NOT NULL COMMENT '强平价',
  `need_liquidate` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否需要强平（0否、1是）',
  `handling_fee` decimal(32,8) NOT NULL COMMENT '手续费',
  `liquidate_fee` decimal(32,8) DEFAULT NULL COMMENT '强平清算费',
  `open_time` datetime NOT NULL COMMENT '开仓时间',
  `close_time` datetime DEFAULT NULL COMMENT '平仓时间',
  `margin_rate` decimal(32,2) DEFAULT NULL COMMENT '保证金率',
  `margin_check_status` varchar(10) NOT NULL COMMENT '保证金率检查状态（0正常、1检查中、2已发送邮件）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位状态（0持仓中、1部分平仓、2全部平仓、3强平中、4已强平）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_position_mode_index` (`mode`),
  KEY `ripple_contract_position_side_index` (`side`),
  KEY `ripple_contract_position_status_index` (`status`),
  KEY `ripple_contract_position_symbol_id_index` (`symbol_id`),
  KEY `ripple_contract_position_user_id_index` (`user_id`),
  KEY `ripple_contract_position_now_num_index` (`now_num`),
  KEY `ripple_contract_position_combination_index` (`is_robot`,`status`,`is_deleted`) USING BTREE,
  KEY `ripple_contract_position_create_time_index` (`create_time`),
  KEY `ripple_contract_position_margin_check_status_index` (`margin_check_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='仓位表';

-- ----------------------------
-- Records of ripple_contract_position
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_position_history
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_position_history`;
CREATE TABLE `ripple_contract_position_history` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `mode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位模式（0逐仓、1全仓）',
  `side` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '方向（0做多、1做空）',
  `multiple` int NOT NULL COMMENT '倍数',
  `is_robot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否机器人（0否、1是）',
  `open_num` decimal(32,8) NOT NULL COMMENT '已开仓量',
  `close_num` decimal(32,8) NOT NULL COMMENT '已平仓量',
  `now_num` decimal(32,8) NOT NULL COMMENT '当前持仓量',
  `max_num` decimal(32,8) NOT NULL COMMENT '最大持仓量',
  `available_num` decimal(32,8) DEFAULT NULL COMMENT '可用数量',
  `closing_num` decimal(32,8) DEFAULT NULL COMMENT '平仓中冻结量',
  `open_avg_price` decimal(32,8) NOT NULL COMMENT '开仓均价',
  `close_avg_price` decimal(32,8) DEFAULT NULL COMMENT '平仓均价',
  `margin` decimal(32,8) NOT NULL COMMENT '保证金',
  `profit` decimal(32,8) DEFAULT NULL COMMENT '平仓收益，平仓后有值',
  `profit_rate` decimal(32,8) DEFAULT NULL COMMENT '平仓收益率，平仓后有值',
  `liquidate_price` decimal(32,8) NOT NULL COMMENT '强平价',
  `need_liquidate` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否需要强平（0否、1是）',
  `handling_fee` decimal(32,8) NOT NULL COMMENT '手续费',
  `liquidate_fee` decimal(32,8) DEFAULT NULL COMMENT '强平清算费',
  `open_time` datetime NOT NULL COMMENT '开仓时间',
  `close_time` datetime DEFAULT NULL COMMENT '平仓时间',
  `margin_rate` decimal(32,2) DEFAULT NULL COMMENT '保证金率',
  `margin_check_status` varchar(10) NOT NULL COMMENT '保证金率检查状态（0正常、1已发送邮件）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位状态（0持仓中、1部分平仓、2全部平仓、3强平中、4已强平）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_position_mode_index` (`mode`),
  KEY `ripple_contract_position_side_index` (`side`),
  KEY `ripple_contract_position_status_index` (`status`),
  KEY `ripple_contract_position_symbol_id_index` (`symbol_id`),
  KEY `ripple_contract_position_user_id_index` (`user_id`),
  KEY `ripple_contract_position_now_num_index` (`now_num`),
  KEY `ripple_contract_position_create_time_index` (`create_time`),
  KEY `ripple_contract_position_margin_check_status_index` (`margin_check_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='历史仓位表';

-- ----------------------------
-- Records of ripple_contract_position_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_position_margin_detail
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_position_margin_detail`;
CREATE TABLE `ripple_contract_position_margin_detail` (
  `id` bigint NOT NULL COMMENT '主键',
  `position_id` bigint NOT NULL COMMENT '仓位id',
  `margin` decimal(32,8) NOT NULL COMMENT '保证金',
  `business_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务类型（0开仓、1平仓、2调整保证金、3全仓自动追加）',
  `operation_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作类型（0加、1减）',
  `liquidate_price` decimal(32,8) NOT NULL COMMENT '强平价',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='仓位保证金变更明细';

-- ----------------------------
-- Records of ripple_contract_position_margin_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_stop_order
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_stop_order`;
CREATE TABLE `ripple_contract_stop_order` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `position_mode` varchar(10) NOT NULL COMMENT '仓位模式（0逐仓、1全仓）1',
  `side` varchar(10) NOT NULL COMMENT '方向（0做多、1做空）',
  `multiple` int NOT NULL COMMENT '倍数',
  `num` decimal(32,8) NOT NULL COMMENT '委托数量',
  `side_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '单向/双向（0单向、1双向）',
  `has_stop_profit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否止盈（0否、1是）',
  `stop_profit_trigger` decimal(32,8) DEFAULT NULL COMMENT '止盈触发价格，是否止盈为是时不能为空',
  `stop_profit_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止盈价格类型（0市价、1限价），是否止盈为是时不能为空',
  `stop_profit_price` decimal(32,8) DEFAULT NULL COMMENT '止盈价格，止盈价格类型为限价时不能为空',
  `has_stop_lost` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否止损（0否、1是）',
  `stop_lost_trigger` decimal(32,8) DEFAULT NULL COMMENT '止损触发价格，是否止损为是时不能为空',
  `stop_lost_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止损价格类型（0市价、1限价），是否止损为是时不能为空',
  `stop_lost_price` decimal(32,8) DEFAULT NULL COMMENT '止损价格，止损价格类型为限价时不能为空',
  `actual_trigger_side` varchar(10) DEFAULT NULL COMMENT '实际触发方向（0止盈、1止损）',
  `actual_num` decimal(32,8) DEFAULT NULL COMMENT '实际委托数量',
  `actual_price` decimal(32,8) DEFAULT NULL COMMENT '实际委托金额',
  `need_stop` varchar(10) NOT NULL COMMENT '是否需要处理止盈止损（0否、1是）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) NOT NULL COMMENT '委托状态（0待生效、1处理中、2已生效、3已撤销、4已过期）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_stop_order_has_stop_lost_index` (`has_stop_lost`),
  KEY `ripple_contract_stop_order_has_stop_profit_index` (`has_stop_profit`),
  KEY `ripple_contract_stop_order_need_stop_index` (`need_stop`),
  KEY `ripple_contract_stop_order_status_index` (`status`),
  KEY `ripple_contract_stop_order_stop_lost_trigger_index` (`stop_lost_trigger`),
  KEY `ripple_contract_stop_order_stop_profit_trigger_index` (`stop_profit_trigger`),
  KEY `ripple_contract_stop_order_symbol_id_index` (`symbol_id`),
  KEY `ripple_contract_stop_order_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='止盈止损委托表';

-- ----------------------------
-- Records of ripple_contract_stop_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_stop_order_history
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_stop_order_history`;
CREATE TABLE `ripple_contract_stop_order_history` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `position_mode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '仓位模式（0逐仓、1全仓）',
  `side` varchar(10) NOT NULL COMMENT '方向（0做多、1做空）',
  `multiple` int NOT NULL COMMENT '倍数',
  `num` decimal(32,8) NOT NULL COMMENT '委托数量',
  `side_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '单向/双向（0单向、1双向）',
  `has_stop_profit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否止盈（0否、1是）',
  `stop_profit_trigger` decimal(32,8) DEFAULT NULL COMMENT '止盈触发价格，是否止盈为是时不能为空',
  `stop_profit_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止盈价格类型（0市价、1限价），是否止盈为是时不能为空',
  `stop_profit_price` decimal(32,8) DEFAULT NULL COMMENT '止盈价格，止盈价格类型为限价时不能为空',
  `has_stop_lost` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否止损（0否、1是）',
  `stop_lost_trigger` decimal(32,8) DEFAULT NULL COMMENT '止损触发价格，是否止损为是时不能为空',
  `stop_lost_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '止损价格类型（0市价、1限价），是否止损为是时不能为空',
  `stop_lost_price` decimal(32,8) DEFAULT NULL COMMENT '止损价格，止损价格类型为限价时不能为空',
  `actual_trigger_side` varchar(10) DEFAULT NULL COMMENT '实际触发方向（0止盈、1止损）',
  `actual_num` decimal(32,8) DEFAULT NULL COMMENT '实际委托数量',
  `actual_price` decimal(32,8) DEFAULT NULL COMMENT '实际委托金额',
  `need_stop` varchar(10) NOT NULL COMMENT '是否需要处理止盈止损（0否、1是）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) NOT NULL COMMENT '委托状态（0待生效、1处理中、2已生效、3已撤销、4已过期）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_stop_order_has_stop_lost_index` (`has_stop_lost`),
  KEY `ripple_contract_stop_order_has_stop_profit_index` (`has_stop_profit`),
  KEY `ripple_contract_stop_order_need_stop_index` (`need_stop`),
  KEY `ripple_contract_stop_order_status_index` (`status`),
  KEY `ripple_contract_stop_order_stop_lost_trigger_index` (`stop_lost_trigger`),
  KEY `ripple_contract_stop_order_stop_profit_trigger_index` (`stop_profit_trigger`),
  KEY `ripple_contract_stop_order_symbol_id_index` (`symbol_id`),
  KEY `ripple_contract_stop_order_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='历史止盈止损委托表';

-- ----------------------------
-- Records of ripple_contract_stop_order_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_symbol
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_symbol`;
CREATE TABLE `ripple_contract_symbol` (
  `id` bigint NOT NULL COMMENT '主键',
  `main_cur_id` bigint NOT NULL COMMENT '主币id',
  `main_cur_name` varchar(200) NOT NULL COMMENT '主币名称',
  `main_cur_accuracy` int DEFAULT NULL COMMENT '主币精度',
  `token_cur_id` bigint NOT NULL COMMENT '外币id',
  `token_cur_name` varchar(200) NOT NULL COMMENT '外币名称',
  `token_cur_accuracy` int DEFAULT NULL COMMENT '外币精度',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '名称',
  `multiple` int NOT NULL COMMENT '最大杠杆倍数',
  `market_fee_rate` decimal(32,8) NOT NULL COMMENT '市价单手续费费率',
  `limit_fee_rate` decimal(32,8) NOT NULL COMMENT '限价单手续费费率',
  `funding_rate` decimal(32,8) DEFAULT NULL COMMENT '资金费率',
  `min_order_num` decimal(32,8) NOT NULL COMMENT '最小下单数量',
  `min_order_price` decimal(32,8) NOT NULL COMMENT '最小下单价格',
  `max_market_order_num` decimal(32,8) NOT NULL COMMENT '市价单单笔最大数量',
  `max_limit_order_num` decimal(32,8) NOT NULL COMMENT '限价单单笔最大数量',
  `max_pending_order_num` int NOT NULL COMMENT '最大挂单数量',
  `max_condition_pending_order_num` int NOT NULL COMMENT '最大条件单挂单数量',
  `min_price_float_unit` decimal(32,8) NOT NULL COMMENT '最小价格波动单位',
  `limit_order_price_cap_ratio` decimal(32,8) NOT NULL COMMENT '限价单价格上限比率',
  `limit_order_price_floor_ratio` decimal(32,8) NOT NULL COMMENT '限价单价格下限比率',
  `is_hot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否是热点数据（0否、1是）',
  `order_no` int NOT NULL COMMENT '顺序号',
  `liquidate_fee_rate` decimal(32,8) NOT NULL COMMENT '强平清算费率',
  `liquidate_advance` decimal(32,8) NOT NULL COMMENT '强平提前量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态(0停用 1正常)',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '是否删除（null是、0否）',
  `max_capital_rate` decimal(32,8) NOT NULL COMMENT '资金费率上限',
  `min_capital_rate` decimal(32,8) NOT NULL COMMENT '资金费率下限',
  `logo_img` varchar(255) DEFAULT NULL COMMENT '币对logo地址',
  `sheet` decimal(16,8) DEFAULT NULL COMMENT '张数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='币对表';

-- ----------------------------
-- Records of ripple_contract_symbol
-- ----------------------------
BEGIN;
INSERT INTO `ripple_contract_symbol` VALUES (1, 2, 'USDT', 2, 1, 'BTC', 3, 'BTCUSDT', 125, 0.06000000, 0.02000000, 0.00030000, 0.00100000, 556.80000000, 2000000.00000000, 4000000.00000000, 200, 10, 0.10000000, 20.00000000, 20.00000000, '1', 0, 0.01500000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-12 16:53:08', 1, '1', '0', 0.00010000, -0.00010000, 'https://rooexchanges.oss-cn-chengdu.aliyuncs.com/a1ea0b25f7034c37944096c3221d2af2.jpeg', 1000.00000000);
INSERT INTO `ripple_contract_symbol` VALUES (2, 2, 'USDT', 2, 3, 'ETH', 3, 'ETHUSDT', 100, 0.06000000, 0.02000000, 0.00030000, 0.00100000, 39.86000000, 2000000.00000000, 4000000.00000000, 200, 10, 0.01000000, 20.00000000, 20.00000000, '1', 0, 0.01500000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-12 16:53:08', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/ETH.png', 100.00000000);
INSERT INTO `ripple_contract_symbol` VALUES (1563770566340661248, 1562385084139474945, 'USDT', 2, 1563765413722624001, 'EOS', 3, 'EOSUSDT', 75, 0.10000000, 0.01000000, 0.00030000, 0.10000000, 0.11100000, 120000.00000000, 1000000.00000000, 200, 10000, 0.00100000, 10.00000000, 10.00000000, '0', 3, 0.15000000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-28 14:08:51', 1, '0', '0', 0.00010000, -0.00010000, '', 0.10000000);
INSERT INTO `ripple_contract_symbol` VALUES (1563790873055088640, 1562385084139474945, 'USDT', 2, 1563783386143297537, 'DOT', 4, 'DOTUSDT', 75, 0.06000000, 0.02000000, 0.00030000, 0.10000000, 0.37300000, 5000000.00000000, 10000000.00000000, 200, 10000, 0.00100000, 5.00000000, 5.00000000, '0', 4, 0.01500000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:29:33', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/DOT.png', 1.00000000);
INSERT INTO `ripple_contract_symbol` VALUES (1563791189934755840, 1562385084139474945, 'USDT', 2, 1563784861280014338, 'BCH', 4, 'BCHUSDT', 75, 0.01000000, 0.10000000, 0.00030000, 0.00100000, 13.93000000, 850.00000000, 10000.00000000, 200, 1000, 0.01000000, 5.00000000, 5.00000000, '0', 5, 1.00000000, 0.01000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:30:48', 1, '0', '0', 0.00010000, -0.00010000, '', 100.00000000);
INSERT INTO `ripple_contract_symbol` VALUES (1563791361074941952, 1562385084139474945, 'USDT', 2, 1563785020504182786, 'BNB', 4, 'BNBUSDT', 75, 0.06000000, 0.02000000, 0.00030000, 0.01000000, 6.60000000, 15000000.00000000, 10000000.00000000, 200, 1000, 0.01000000, 5.00000000, 5.00000000, '1', 6, 0.01500000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:31:29', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/BNB.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563791551462789120, 1562385084139474945, 'USDT', 2, 1563785060182298625, 'XRP', 4, 'XRPUSDT', 75, 0.10000000, 0.01000000, 0.00030000, 0.10000000, 0.01430000, 500000.00000000, 1000000.00000000, 200, 1000, 0.00010000, 5.00000000, 5.00000000, '0', 7, 0.50000000, 0.10000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:32:14', 1, '0', '0', 0.00010000, -0.00010000, '', 0.01000000);
INSERT INTO `ripple_contract_symbol` VALUES (1563791751229100032, 1562385084139474945, 'USDT', 2, 1563785082735071233, 'ADA', 4, 'ADAUSDT', 75, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.01740000, 300000.00000000, 2000000.00000000, 200, 1000, 0.00010000, 5.00000000, 5.00000000, '0', 8, 0.50000000, 0.10000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:33:02', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563792055450357760, 1562385084139474945, 'USDT', 2, 1563785107070423042, 'SOL', 4, 'SOLUSDT', 50, 0.06000000, 0.02000000, 0.00030000, 1.00000000, 0.42000000, 90000.00000000, 1000000.00000000, 200, 10, 0.01000000, 10.00000000, 10.00000000, '1', 9, 0.01500000, 0.50000000, '2022-08-12 16:53:01', 1, '2022-08-28 15:34:15', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/SOL.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563792425962590208, 1562385084139474945, 'USDT', 5, 1563785137227468802, 'DOGE', 6, 'DOGEUSDT', 50, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.00244000, 2500000.00000000, 10000000.00000000, 200, 1000, 0.00001000, 10.00000000, 10.00000000, '0', 10, 1.50000000, 0.10000000, '2022-08-28 15:35:43', 1, '2022-08-28 15:35:43', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/DOGE.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563792557227528192, 1562385084139474945, 'USDT', 2, 1563785250851164161, 'USDT', 4, 'USDT', 125, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.00015700, 20000000.00000000, 10000000.00000000, 200, 1000, 0.00000100, 10.00000000, 10.00000000, '0', 11, 1.50000000, 0.10000000, '2022-08-28 15:36:14', 1, '2022-08-28 15:36:14', 1, '1', NULL, 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563792776396689408, 1562385084139474945, 'USDT', 4, 1563785273001283586, 'MATIC', 4, 'MATICUSDT', 50, 0.06000000, 0.02000000, 0.00030000, 1.00000000, 0.00960000, 500000.00000000, 10000000.00000000, 200, 10000, 0.00010000, 10.00000000, 10.00000000, '0', 12, 0.15000000, 0.50000000, '2022-08-28 15:37:06', 1, '2022-08-28 15:37:06', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/MATIC.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563792928675090432, 1562385084139474945, 'USDT', 3, 1563785297814786050, 'AVAX', 4, 'AVAXUSDT', 50, 0.06000000, 0.02000000, 0.00030000, 1.00000000, 0.35000000, 50000.00000000, 100000.00000000, 200, 10, 0.01000000, 10.00000000, 10.00000000, '0', 13, 0.01500000, 0.50000000, '2022-08-28 15:37:43', 1, '2022-08-28 15:37:43', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/AVAX.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793085013577728, 1562385084139474945, 'USDT', 2, 1563785320996704257, 'TRX', 4, 'TRXUSDT', 25, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.00132000, 5000000.00000000, 10000000.00000000, 200, 10000, 0.00001000, 5.00000000, 5.00000000, '0', 14, 0.50000000, 0.10000000, '2022-08-28 15:38:20', 1, '2022-08-28 15:38:20', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/TRX.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793297081782272, 1562385084139474945, 'USDT', 2, 1563785356920918018, 'FTT', 4, 'FTTUSDT', 25, 0.10000000, 0.10000000, 0.00030000, 0.10000000, 0.00100000, 1200.00000000, 1000000.00000000, 200, 10000, 0.00100000, 5.00000000, 5.00000000, '0', 15, 1.00000000, 0.10000000, '2022-08-28 15:39:11', 1, '2022-08-28 15:39:11', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793440384372736, 1562385084139474945, 'USDT', 2, 1563785378332839938, 'ETC', 4, 'ETCUSDT', 75, 0.06000000, 0.02000000, 0.00030000, 0.01000000, 1.05100000, 10000.00000000, 100000.00000000, 200, 1000, 0.00100000, 10.00000000, 10.00000000, '0', 16, 0.15000000, 0.50000000, '2022-08-28 15:39:45', 1, '2022-08-28 15:39:45', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/ETC.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793563776602112, 1562385084139474945, 'USDT', 3, 1563785401812553730, 'UNI', 4, 'UNIUSDT', 25, 0.06000000, 0.02000000, 0.00030000, 1.00000000, 0.37300000, 25000.00000000, 10000000.00000000, 200, 10000, 0.00100000, 10.00000000, 10.00000000, '0', 17, 0.15000000, 0.50000000, '2022-08-28 15:40:14', 1, '2022-08-28 15:40:14', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/UNI.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793700297003008, 1562385084139474945, 'USDT', 2, 1563785423631323138, 'OKB', 4, 'OKBUSDT', 1000, 0.10000000, 0.10000000, 0.00030000, 0.10000000, 0.10000000, 10000.00000000, 10000.00000000, 10000, 10000, 0.10000000, 0.10000000, 0.10000000, '0', 18, 0.10000000, 0.10000000, '2022-08-28 15:40:47', 1, '2022-08-28 15:40:47', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793837815648256, 1562385084139474945, 'USDT', 2, 1563785443319386114, 'LTC', 4, 'LTCUSDT', 75, 0.06000000, 0.02000000, 0.00030000, 0.00100000, 3.61000000, 3000.00000000, 10000.00000000, 200, 10000, 0.01000000, 5.00000000, 5.00000000, '0', 19, 0.15000000, 0.50000000, '2022-08-28 15:41:20', 1, '2022-08-28 15:41:20', 1, '1', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/LTC.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563793977804738560, 1562385084139474945, 'USDT', 2, 1563785465331093505, 'ATOM', 4, 'ATOMUSDT', 25, 0.10000000, 0.10000000, 0.00030000, 0.01000000, 0.25100000, 20000.00000000, 100000.00000000, 200, 10000, 0.00100000, 10.00000000, 10.00000000, '0', 20, 0.50000000, 0.10000000, '2022-08-28 15:41:53', 1, '2022-08-28 15:41:53', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/ATOM.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794219816079360, 1562385084139474945, 'USDT', 2, 1563785489616113666, 'LINK', 4, 'LINKUSDT', 75, 0.10000000, 0.10000000, 0.00030000, 0.01000000, 0.46400000, 20000.00000000, 100000.00000000, 200, 10000, 0.00100000, 10.00000000, 10.00000000, '0', 21, 0.50000000, 0.10000000, '2022-08-28 15:42:51', 1, '2022-08-28 15:42:51', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/LINK.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794353090088960, 1562385084139474945, 'USDT', 2, 1563785522948247554, 'CRO', 4, 'CROUSDT', 1000, 0.10000000, 0.10000000, 0.00030000, 0.10000000, 0.10000000, 10000.00000000, 10000.00000000, 10000, 10000, 0.10000000, 0.10000000, 0.10000000, '0', 22, 0.10000000, 0.10000000, '2022-08-28 15:43:22', 1, '2022-08-28 15:43:22', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794489082007552, 1562385084139474945, 'USDT', 2, 1563785557362511873, 'NEAR', 4, 'NEARUSDT', 50, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.04800000, 24000.00000000, 10000000.00000000, 200, 1000, 0.00100000, 10.00000000, 10.00000000, '0', 23, 1.00000000, 0.10000000, '2022-08-28 15:43:55', 1, '2022-08-28 15:43:55', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/NEAR.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794621810757632, 1562385084139474945, 'USDT', 2, 1563785585443377153, 'XLM', 4, 'XLMUSDT', 50, 0.10000000, 0.10000000, 0.00030000, 1.00000000, 0.00648000, 1000000.00000000, 10000000.00000000, 200, 10000, 0.00001000, 5.00000000, 5.00000000, '0', 24, 1.00000000, 0.10000000, '2022-08-28 15:44:26', 1, '2022-08-28 15:44:26', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794760935821312, 1562385084139474945, 'USDT', 2, 1563785607207620610, 'XMR', 4, 'XMRUSDT', 50, 0.10000000, 0.10000000, 0.00030000, 0.00100000, 4.36000000, 2000.00000000, 10000.00000000, 200, 10000, 0.01000000, 5.00000000, 5.00000000, '0', 25, 1.00000000, 0.10000000, '2022-08-28 15:45:00', 1, '2022-08-28 15:45:00', 1, '0', '0', 0.00010000, -0.00010000, '', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563794893106728960, 1562385084139474945, 'USDT', 2, 1563785632880955393, 'FLOW', 4, 'FLOWUSDT', 25, 0.10000000, 0.10000000, 0.00030000, 0.10000000, 0.01000000, 6000.00000000, 1000000.00000000, 200, 10000, 0.00100000, 10.00000000, 10.00000000, '0', 26, 1.00000000, 0.10000000, '2022-08-28 15:45:31', 1, '2022-08-28 15:45:31', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/tether_看图王.web.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1563795052658053120, 1562385084139474945, 'USDT', 2, 1563785663566483457, 'ALGO', 4, 'ALGOUSDT', 25, 0.10000000, 0.10000000, 0.00030000, 0.10000000, 0.01410000, 500000.00000000, 1000000.00000000, 200, 10000, 0.00010000, 5.00000000, 5.00000000, '0', 27, 1.00000000, 0.10000000, '2022-08-28 15:46:09', 1, '2022-08-28 15:46:09', 1, '0', '0', 0.00010000, -0.00010000, 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/fz.png', NULL);
INSERT INTO `ripple_contract_symbol` VALUES (1580123848021540864, 1562385084139474945, 'USDT', 2, 1562383321713905666, 'ROO', 3, 'ROOUSDT', 125, 0.06000000, 0.02000000, 0.00030000, 0.00100000, 556.80000000, 2000000.00000000, 4000000.00000000, 200, 10, 0.10000000, 20.00000000, 20.00000000, '1', 0, 0.01500000, 0.50000000, '2022-10-12 17:10:57', 1, '2022-10-12 17:10:57', 1, '1', '0', 0.00010000, 0.00010000, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_symbol_hierarchy
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_symbol_hierarchy`;
CREATE TABLE `ripple_contract_symbol_hierarchy` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `hierarchy` int NOT NULL DEFAULT '0' COMMENT '层级',
  `start_multiple` int NOT NULL DEFAULT '0' COMMENT '最低杠杆倍数',
  `end_multiple` int NOT NULL DEFAULT '0' COMMENT '最高杠杆倍数',
  `min_position` decimal(32,8) NOT NULL DEFAULT '0.00000000' COMMENT '最低持仓',
  `max_position` decimal(32,8) DEFAULT NULL COMMENT '最高持仓',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='币对层级(头寸)';

-- ----------------------------
-- Records of ripple_contract_symbol_hierarchy
-- ----------------------------
BEGIN;
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206059708416, 1563770566340661248, 'EOSUSDT', 1, 51, 100, 50000.00000000, 250000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206240063488, 1563770566340661248, 'EOSUSDT', 2, 21, 50, 250000.00000000, 1000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206344921088, 1563770566340661248, 'EOSUSDT', 3, 11, 20, 1000000.00000000, 10000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206617550848, 1563770566340661248, 'EOSUSDT', 4, 6, 10, 10000000.00000000, 20000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206709825536, 1563770566340661248, 'EOSUSDT', 5, 5, 5, 20000000.00000000, 50000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206776934400, 1563770566340661248, 'EOSUSDT', 6, 4, 4, 50000000.00000000, 100000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905206873403392, 1563770566340661248, 'EOSUSDT', 7, 3, 3, 100000000.00000000, 200000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905207028592640, 1563770566340661248, 'EOSUSDT', 8, 2, 2, 200000000.00000000, 300000000.00000000, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905207104090112, 1563770566340661248, 'EOSUSDT', 9, 1, 1, 300000000.00000000, NULL, '2022-09-11 18:12:05', 1, '2022-09-11 18:12:05', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223151497216, 1563790873055088640, 'DOTUSDT', 1, 51, 100, 50000.00000000, 250000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223247966208, 1563790873055088640, 'DOTUSDT', 2, 21, 50, 250000.00000000, 1000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223340240896, 1563790873055088640, 'DOTUSDT', 3, 11, 20, 1000000.00000000, 10000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223432515584, 1563790873055088640, 'DOTUSDT', 4, 6, 10, 10000000.00000000, 20000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223587704832, 1563790873055088640, 'DOTUSDT', 5, 5, 5, 20000000.00000000, 50000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223705145344, 1563790873055088640, 'DOTUSDT', 6, 4, 4, 50000000.00000000, 100000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223797420032, 1563790873055088640, 'DOTUSDT', 7, 3, 3, 100000000.00000000, 200000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223889694720, 1563790873055088640, 'DOTUSDT', 8, 2, 2, 200000000.00000000, 300000000.00000000, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905223981969408, 1563790873055088640, 'DOTUSDT', 9, 1, 1, 300000000.00000000, NULL, '2022-09-11 18:12:09', 1, '2022-09-11 18:12:09', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905241811955712, 1563791189934755840, 'BCHUSDT', 1, 51, 100, 50000.00000000, 250000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905241895841792, 1563791189934755840, 'BCHUSDT', 2, 21, 50, 250000.00000000, 1000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905241971339264, 1563791189934755840, 'BCHUSDT', 3, 11, 20, 1000000.00000000, 10000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242172665856, 1563791189934755840, 'BCHUSDT', 4, 6, 10, 10000000.00000000, 20000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242248163328, 1563791189934755840, 'BCHUSDT', 5, 5, 5, 20000000.00000000, 50000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242420129792, 1563791189934755840, 'BCHUSDT', 6, 4, 4, 50000000.00000000, 100000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242524987392, 1563791189934755840, 'BCHUSDT', 7, 3, 3, 100000000.00000000, 200000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242604679168, 1563791189934755840, 'BCHUSDT', 8, 2, 2, 200000000.00000000, 300000000.00000000, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1568905242684370944, 1563791189934755840, 'BCHUSDT', 9, 1, 1, 300000000.00000000, NULL, '2022-09-11 18:12:13', 1, '2022-09-11 18:12:13', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1569152200866975744, 1563793440384372736, 'ETCUSDT', 1, 0, 0, 0.00000000, 0.00000000, '2022-09-12 10:33:33', 2, '2022-09-12 10:33:33', 2, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155234886782976, 1, 'BTCUSDT', 1, 101, 125, 0.00100000, 50.00000000, '2022-09-11 12:21:42', 1, '2022-09-11 12:21:42', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155234928726016, 1, 'BTCUSDT', 2, 51, 100, 0.00100000, 2500.00000000, '2022-09-11 12:21:42', 1, '2022-09-11 12:21:42', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155234983251968, 1, 'BTCUSDT', 3, 21, 50, 0.00100000, 10000.00000000, '2022-09-11 12:21:42', 1, '2022-09-11 12:21:42', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235025195008, 1, 'BTCUSDT', 4, 11, 20, 0.00100000, 10000000.00000000, '2022-09-11 12:21:42', 1, '2022-09-11 12:21:42', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235075526656, 1, 'BTCUSDT', 5, 6, 10, 0.00100000, 20000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235151024128, 1, 'BTCUSDT', 6, 5, 5, 0.00100000, 50000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235209744384, 1, 'BTCUSDT', 7, 4, 4, 50000000.00000000, 100000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235251687424, 1, 'BTCUSDT', 8, 3, 3, 100000000.00000000, 200000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235314601984, 1, 'BTCUSDT', 9, 2, 2, 200000000.00000000, 300000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155235364933632, 1, 'BTCUSDT', 10, 1, 1, 300000005.00000000, 30000000000.00000000, '2022-09-11 12:21:43', 1, '2022-09-11 12:21:43', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303480430592, 2, 'ETHUSDT', 1, 101, 125, 0.00100000, 10000.00000000, '2022-09-12 14:03:52', 1, '2022-09-12 14:03:52', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303518179328, 2, 'ETHUSDT', 2, 51, 100, 0.00100000, 100000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303572705280, 2, 'ETHUSDT', 3, 21, 50, 0.00100000, 1000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303618842624, 2, 'ETHUSDT', 4, 11, 20, 0.00100000, 10000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303656591360, 2, 'ETHUSDT', 5, 6, 10, 0.00100000, 20000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303694340096, 2, 'ETHUSDT', 6, 5, 5, 0.00100000, 50000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303744671744, 2, 'ETHUSDT', 7, 4, 4, 100000.00000000, 100000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303778226176, 2, 'ETHUSDT', 8, 3, 3, 100000000.00000000, 200000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303832752128, 2, 'ETHUSDT', 9, 2, 2, 200000000.00000000, 300000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155303866306560, 2, 'ETHUSDT', 10, 1, 1, 300000000.00000000, 1000000000.00000000, '2022-09-11 18:12:00', 1, '2022-09-11 18:12:00', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572155759933952000, 1563792928675090432, 'AVAXUSDT', 1, 51, 75, 2000.00000000, 1000000.00000000, '2022-09-20 17:28:37', 1, '2022-09-20 17:28:37', 1, '0');
INSERT INTO `ripple_contract_symbol_hierarchy` VALUES (1572427088855728128, 1563791361074941952, 'BNBUSDT', 1, 0, 125, 0.00000000, 30000.00000000, '2022-09-14 16:10:08', 1, '2022-09-14 16:10:08', 1, '0');
COMMIT;

-- ----------------------------
-- Table structure for ripple_contract_trade
-- ----------------------------
DROP TABLE IF EXISTS `ripple_contract_trade`;
CREATE TABLE `ripple_contract_trade` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `order_id` bigint NOT NULL COMMENT '订单id',
  `order_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '订单类型（0市价单、1限价单、2强平单）',
  `maker_user_id` bigint NOT NULL COMMENT '对手盘用户id',
  `maker_order_id` bigint NOT NULL COMMENT '对手盘订单id',
  `maker_trade_id` bigint NOT NULL COMMENT '对手盘成交记录id',
  `position_id` bigint NOT NULL COMMENT '仓位id',
  `is_buy` varchar(10) NOT NULL COMMENT '是否是买单（0否，是卖单、1是）',
  `is_robot` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否机器人（0否、1是）',
  `side` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '订单方向（0做多、1做空）',
  `operation_type` varchar(10) NOT NULL COMMENT '操作类型（0开仓、1平仓）',
  `price` decimal(32,8) DEFAULT NULL COMMENT '成交价格',
  `num` decimal(32,8) DEFAULT NULL COMMENT '成交数量',
  `trade_value` decimal(32,8) NOT NULL COMMENT '交易面值',
  `multiple` int NOT NULL COMMENT '倍数',
  `handling_fee` decimal(32,8) NOT NULL COMMENT '手续费',
  `handling_fee_rate` decimal(32,8) NOT NULL COMMENT '手续费率',
  `margin` decimal(32,8) DEFAULT NULL COMMENT '保证金',
  `liquidate_fee` decimal(32,8) DEFAULT NULL COMMENT '强平清算费',
  `profit` decimal(32,8) DEFAULT NULL COMMENT '收益，平仓时有值',
  `liquidate_fee_rate` decimal(32,8) DEFAULT NULL COMMENT '强平清算费率',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态（暂无作用）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ripple_contract_trade_order_id_index` (`order_id`),
  KEY `ripple_contract_trade_position_id_index` (`position_id`),
  KEY `ripple_contract_trade_symbol_id_index` (`symbol_id`),
  KEY `ripple_contract_trade_user_id_index` (`user_id`),
  KEY `ripple_contract_trade_operation_type_index` (`operation_type`),
  KEY `ripple_contract_trade_side_index` (`side`),
  KEY `ripple_contract_trade_status_index` (`status`),
  KEY `ripple_contract_trade_update_time_index` (`update_time` DESC) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='成交记录表';

-- ----------------------------
-- Records of ripple_contract_trade
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_config
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_config`;
CREATE TABLE `ripple_robot_config` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `num_float` decimal(16,8) NOT NULL COMMENT '来源',
  `price_float` decimal(16,8) NOT NULL COMMENT '价格',
  `price_fluctuation_toplimit` decimal(18,8) NOT NULL COMMENT '价格浮动上限',
  `price_fluctuation_lowerlimit` decimal(18,8) unsigned NOT NULL COMMENT '价格浮动下限',
  `quantity_toplimit` decimal(18,8) NOT NULL COMMENT '下单数量上限',
  `quantity_lowerlimit` decimal(18,8) NOT NULL COMMENT '下单数量下限',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态（0停用、1启用）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0' COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='机器人列表';

-- ----------------------------
-- Records of ripple_robot_config
-- ----------------------------
BEGIN;
INSERT INTO `ripple_robot_config` VALUES (1, 1, 'BTCUSDT', 1.50000000, 2.00000000, 0.00000000, 0.00000000, 1.00000000, 0.10000000, '2022-08-26 20:10:32', NULL, NULL, NULL, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563422576749002752, 2, 'ETHUSDT', 1213.00000000, 1212.00000000, 0.00000000, 0.00000000, 10.00000000, 0.10000000, '2022-08-27 15:06:04', 1, '2022-08-27 15:06:04', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563808223411081216, 1563770566340661248, 'EOSUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 16:38:29', 1, '2022-08-28 16:38:29', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813509156835328, 1563790873055088640, 'DOTUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 16:59:29', 1, '2022-08-28 16:59:29', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813619836129280, 1563791189934755840, 'BCHUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 16:59:56', 1, '2022-08-28 16:59:56', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813687188262912, 1563791361074941952, 'BNBUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:00:12', 1, '2022-08-28 17:00:12', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813752158031872, 1563791551462789120, 'XRPUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:00:27', 1, '2022-08-28 17:00:27', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813816091807744, 1563791751229100032, 'ADAUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:00:43', 1, '2022-08-28 17:00:43', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813902981009408, 1563792055450357760, 'SOLUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:01:03', 1, '2022-08-28 17:01:03', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563813959625084928, 1563792425962590208, 'DOGEUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:01:17', 1, '2022-08-28 17:01:17', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814022447370240, 1563792557227528192, 'SHIBUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:01:32', 1, '2022-08-28 17:01:32', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814103863005184, 1563792776396689408, 'MATICUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:01:51', 1, '2022-08-28 17:01:51', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814196875890688, 1563792928675090432, 'AVAXUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:02:13', 1, '2022-08-28 17:02:13', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814255675838464, 1563793085013577728, 'TRXUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:02:27', 1, '2022-08-28 17:02:27', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814317076254720, 1563793297081782272, 'FTTUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:02:42', 1, '2022-08-28 17:02:42', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814380427022336, 1563793440384372736, 'ETCUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 10.00000000, 0.10000000, '2022-08-28 17:02:57', 1, '2022-08-28 17:02:57', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814447938539520, 1563793563776602112, 'UNIUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 10.00000000, 0.10000000, '2022-08-28 17:03:13', 1, '2022-08-28 17:03:13', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814506751070208, 1563793700297003008, 'OKBUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 10.00000000, 0.10000000, '2022-08-28 17:03:27', 1, '2022-08-28 17:03:27', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814579710988288, 1563793837815648256, 'LTCUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 10.00000000, 0.10000000, '2022-08-28 17:03:45', 1, '2022-08-28 17:03:45', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814700775378944, 1563793977804738560, 'ATOMUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 10.00000000, 0.10000000, '2022-08-28 17:04:14', 1, '2022-08-28 17:04:14', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814774792261632, 1563794219816079360, 'LINKUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:04:31', 1, '2022-08-28 17:04:31', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814863350796288, 1563794353090088960, 'CROUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:04:52', 1, '2022-08-28 17:04:52', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563814947874410496, 1563794489082007552, 'NEARUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:05:13', 1, '2022-08-28 17:05:13', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563815013435576320, 1563794621810757632, 'XLMUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:05:28', 1, '2022-08-28 17:05:28', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563815084654858240, 1563794760935821312, 'XMRUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:05:45', 1, '2022-08-28 17:05:45', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563815143526109184, 1563794893106728960, 'FLOWUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:05:59', 1, '2022-08-28 17:05:59', 1, '1', '0');
INSERT INTO `ripple_robot_config` VALUES (1563815339941179392, 1563795052658053120, 'ALGOUSDT', 0.00000000, 0.00000000, 0.05000000, 0.05000000, 20.00000000, 0.10000000, '2022-08-28 17:06:46', 1, '2022-08-28 17:06:46', 1, '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_control_price
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_control_price`;
CREATE TABLE `ripple_robot_control_price` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `initial_price` decimal(16,8) NOT NULL COMMENT '初始价格',
  `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0停用、1启用）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='控盘机器人';

-- ----------------------------
-- Records of ripple_robot_control_price
-- ----------------------------
BEGIN;
INSERT INTO `ripple_robot_control_price` VALUES (1, 1580123848021540864, 'ROOUSDT', 500.00000000, '1', '2022-10-12 11:46:17', 1, '2022-10-12 11:46:21', 1);
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_control_price_target
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_control_price_target`;
CREATE TABLE `ripple_robot_control_price_target` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `target_price` decimal(16,8) DEFAULT NULL COMMENT '目标价格',
  `target_time` bigint DEFAULT NULL COMMENT '目标价格达成时间 (时间戳)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='控盘机器人目标配置';

-- ----------------------------
-- Records of ripple_robot_control_price_target
-- ----------------------------
BEGIN;
INSERT INTO `ripple_robot_control_price_target` VALUES (1580168293479763968, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665584100000);
INSERT INTO `ripple_robot_control_price_target` VALUES (1580169274305167360, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665584000000);
INSERT INTO `ripple_robot_control_price_target` VALUES (1580169470938333184, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665583900000);
INSERT INTO `ripple_robot_control_price_target` VALUES (1580169659459768320, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665583800000);
INSERT INTO `ripple_robot_control_price_target` VALUES (1580175228212023296, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665583446917);
INSERT INTO `ripple_robot_control_price_target` VALUES (1580175314895704064, 1580123848021540864, 'ROOUSDT', 600.00000000, 1665583445917);
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_market_record
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_market_record`;
CREATE TABLE `ripple_robot_market_record` (
  `id` bigint NOT NULL COMMENT '主键',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '币对名称',
  `source` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '来源',
  `price` decimal(16,8) NOT NULL COMMENT '标记价',
  `time_stamp` bigint NOT NULL COMMENT '时间戳（毫秒）',
  `spot_index_price` decimal(16,8) DEFAULT NULL COMMENT '现货指数价格',
  `funding_rate` decimal(16,8) DEFAULT NULL COMMENT '资金费率',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态',
  `is_deleted` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否删除（null是、0否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='抓取行情记录表';

-- ----------------------------
-- Records of ripple_robot_market_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_place_order
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_place_order`;
CREATE TABLE `ripple_robot_place_order` (
  `id` bigint NOT NULL COMMENT '主键',
  `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
  `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态  0 启用 1 禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下单机器人';

-- ----------------------------
-- Records of ripple_robot_place_order
-- ----------------------------
BEGIN;
INSERT INTO `ripple_robot_place_order` VALUES (1, '1', '0', '2022-10-10 13:47:32', 1, '2022-10-10 13:47:47', 1);
INSERT INTO `ripple_robot_place_order` VALUES (2, '2', '0', '2022-10-10 13:47:35', 1, '2022-10-10 13:47:49', 1);
INSERT INTO `ripple_robot_place_order` VALUES (3, '3', '0', '2022-10-10 13:47:37', 1, '2022-10-10 13:47:52', 1);
INSERT INTO `ripple_robot_place_order` VALUES (4, '4', '0', '2022-10-10 13:47:39', 1, '2022-10-10 13:47:55', 1);
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_place_order_blacklist
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_place_order_blacklist`;
CREATE TABLE `ripple_robot_place_order_blacklist` (
  `id` bigint NOT NULL COMMENT '主键',
  `robot_place_order_id` bigint NOT NULL COMMENT '下单机器人id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型 0 市价 1 限价',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下单机器人黑名单';

-- ----------------------------
-- Records of ripple_robot_place_order_blacklist
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ripple_robot_place_order_option
-- ----------------------------
DROP TABLE IF EXISTS `ripple_robot_place_order_option`;
CREATE TABLE `ripple_robot_place_order_option` (
  `id` bigint NOT NULL COMMENT '主键',
  `robot_place_order_id` bigint NOT NULL COMMENT '下单机器人id',
  `symbol_id` bigint NOT NULL COMMENT '币对id',
  `symbol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `max_num` decimal(16,8) DEFAULT '0.00000000' COMMENT '最大吃单量(币)',
  `min_num` decimal(16,8) DEFAULT '0.00000000' COMMENT '最小吃单量(币)',
  `price_range` decimal(16,8) DEFAULT NULL COMMENT '吃单价格范围(限价时有值)',
  `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型  0 市价  1 限价',
  `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态  0 启用  1 禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下单机器人配置';

-- ----------------------------
-- Records of ripple_robot_place_order_option
-- ----------------------------
BEGIN;
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115514748981248, 1, 1, 'BTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115514832867328, 1, 1, 'BTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115514887393280, 1, 2, 'ETHUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115514937724928, 1, 2, 'ETHUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515000639488, 1, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515042582528, 1, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515097108480, 1, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515139051520, 1, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515185188864, 1, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515231326208, 1, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515264880640, 1, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515302629376, 1, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515327795200, 1, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515361349632, 1, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515399098368, 1, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515424264192, 1, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515449430016, 1, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515474595840, 1, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515503955968, 1, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515533316096, 1, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515566870528, 1, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115515587842048, 1, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528502104064, 2, 1, 'BTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528548241408, 2, 1, 'BTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528598573056, 2, 2, 'ETHUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528640516096, 2, 2, 'ETHUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528682459136, 2, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528724402176, 2, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528778928128, 2, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528820871168, 2, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528862814208, 2, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528925728768, 2, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115528967671808, 2, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529005420544, 2, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529076723712, 2, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529110278144, 2, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529148026880, 2, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529185775616, 2, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529219330048, 2, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529248690176, 2, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529282244608, 2, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529315799040, 2, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529349353472, 2, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115529374519296, 2, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115541970014208, 3, 1, 'BTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542028734464, 3, 1, 'BTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542070677504, 3, 2, 'ETHUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542108426240, 3, 2, 'ETHUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542141980672, 3, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542183923712, 3, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542225866752, 3, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542255226880, 3, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542288781312, 3, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542322335744, 3, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542376861696, 3, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542410416128, 3, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542439776256, 3, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542473330688, 3, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542506885120, 3, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542540439552, 3, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542569799680, 3, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542594965504, 3, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542632714240, 3, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542662074368, 3, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542699823104, 3, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115542733377536, 3, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561318338560, 4, 1, 'BTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561360281600, 4, 1, 'BTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561406418944, 4, 2, 'ETHUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561435779072, 4, 2, 'ETHUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561465139200, 4, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561498693632, 4, 1563790873055088640, 'DOTUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561536442368, 4, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561569996800, 4, 1563791361074941952, 'BNBUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561595162624, 4, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561632911360, 4, 1563792055450357760, 'SOLUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561666465792, 4, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561695825920, 4, 1563792425962590208, 'DOGEUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561725186048, 4, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561762934784, 4, 1563792776396689408, 'MATICUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561792294912, 4, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561825849344, 4, 1563792928675090432, 'AVAXUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561855209472, 4, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561884569600, 4, 1563793440384372736, 'ETCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561926512640, 4, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561951678464, 4, 1563793563776602112, 'UNIUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115561985232896, 4, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, 1.00000000, '1', '0');
INSERT INTO `ripple_robot_place_order_option` VALUES (1580115562035564544, 4, 1563793837815648256, 'LTCUSDT', 10.00000000, 0.00000000, NULL, '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `branch_id` bigint NOT NULL,
  `xid` varchar(100) NOT NULL,
  `context` varchar(128) NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3696718 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
